package com.fengxing.ams.web.facade.mouble.luqu;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.data.repository.query.Param;

public interface IMajorEnrollDAO extends
		PagingAndSortingRepository<MajorEnrollVO, Integer>,
		JpaSpecificationExecutor<MajorEnrollVO> {

	@Query("select t from MajorEnrollVO t where t.college_id = :college_id and t.major_id = :major_id and t.subject = :subject")
	List<MajorEnrollVO> getMajorEnrollList(
			@Param("college_id") Integer college_id,
			@Param("major_id") String major_id, @Param("subject") String subject);

}
